The database selected by the SQLSelect function reads the number of records that satisfy the conditional clause from the database connected by SQLConnect.
SQLGetCount is used after SQLSelect, but SQLQueryGetCount can be used to quickly read a count that satisfies the conditions of the database without SQLSelect.
int @SQLQueryCount(int id, string table, string where);
Parameters
int id : Access number connected by SQLConnect
string table : Name of the table to query
string where : Search criteria
Return Value
The number of records read is returned
Example
count = @SQLQueryCount(id,"Table1","Name='abc'");
Description : Table1 reads the number of records that meet the condition with Name 'abc'.
Related Helps)
버전 정보
버전 8.5.0 부터 지원